package com.mx.iecisa.oaxaca;

import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;

/**
 * 
 * @author jparanda
 *
 */
public class Constants {
	
	
	public static final List<String> LISTA_PREDIOS_SOCIALES= new ArrayList<String>(Arrays.asList("PRIVADA","SOCIAL","EJIDAL","COMUNAL"));
	public static final String RUTA_ARCHIVO_EXCEL="C:\\JuanPabloAranda\\Iecisa\\Mexico\\Catastro\\Oaxaca\\CargaDeDatos\\ClearData\\";
	public static final String NOMBRE_ARCHIVO_EXCEL="Lachigolo.xlsx";
	public static final String STRING_VALOR_NINGUNO="NINGUNO";
	public static final String STRING_VALOR_SIN_NOMBRE="SIN NOMBRE";
	public static final int COLUMN_TIPO_VIALIDAD=30;
	public static final int COLUMN_CALLE=31;
	public static final int COLUMN_COL_FUH=34;
	public static final int COLUMN_DESC_CFUH=35;
	public static final int COLUMN_TENEN_TIE=73;
	public static final String PATTERN_WITH_NUMBERS="[^a-zA-Z0-9\\s]";
	public static final String PATTERN_WITHOUT_NUMBERS="[^a-zA-Z\\s]";
	public static final List<String> tipoValidades_IGENI= new ArrayList<String>(Arrays.asList("AMPLIACION","ANDADOR","AVENIDA","BOULEVARD",
																						 "CALLE","CALLEJON","CALZADA","CERRADA","CIRCUITO",
																						 "CIRCULACION","CONTINUACION","CORREDOR","DIAGONAL",
																						 "EJE VIAL","PASAJE","PEATONAL","PERIFERICO","PRIVADA",
																						 "PROLONGACION","RETORNO","VIADUCTO","CARRETERA","CAMINO",
																						 "TERRACERIA","BRECHA","VEREDA"));
	
	
	public static final List<String> tipoAsentamientos_INEGI=new ArrayList<String>(Arrays.asList("AEROPUERTO","AMPLIACION","BARRIO","CANTON","CIUDAD",
																								 "CIUDAD INDUSTRIAL","COLONIA","CONDOMINIO",
																								 "CONJUNTO HABITACIONAL","CORREDOR INDUSTRIAL","COTO",
																								 "CUARTEL","EJIDO","EXHACIENDA","FRACCION","FRACCIONAMIENTO",
																								 "GRANJA","HACIENDA","INGENIO","MANZANA","PARAJE",
																								 "PARQUE INDUSTRIAL","PRIVADA","PROLONGACION","PUEBLO",
																								 "PUERTO","RANCHERIA","RANCHO","REGION","RESIDENCIAL",
																								 "RINCONADA","SECCION","SECTOR","SUPERMANZANA","UNIDAD",
																								 "UNIDAD HABITACIONAL","VILLA","ZONA FEDERAL",
																								 "ZONA INDUSTRIAL","ZONA MILITAR","ZONA NAVAL"));
	public static final String FILE_COLUMN_VIALIDADES_CLEARED="Column_ValiadadesCleared.txt";
	public static final String FILE_COLUMN_CALLE_CLEARED="Columna_Col_Calle.txt";
	public static final String FILE_COLUMN_DESC_CFUH_CLEARED="Columna_Col_Desc_cfuh.txt";
	public static final String FILE_COLUMN_COL_FUH_CLEARED="Columna_Col_fuh.txt";
	public static final String FILE_COLUMN_TENEN_TIE_CLEARED="Columna_Col_Tenen_Tie.txt";
	
	
	/**
	 * Constantes para limpieza especifica de las columnas
	 * Calle y Desc_Cfuh
	 */
	public static String NOMBRE_CALLE_OR_DESC_CFUH_ERROR_1="FRACCION";
	public static String NOMBRE_CALLE_OR_DESC_CFUH_ERROR_2="FRACCIONES";
	
	
	public static String getPathFileColumnVialidadesSaved(){
		return RUTA_ARCHIVO_EXCEL+FILE_COLUMN_VIALIDADES_CLEARED;
	}
	

	public static String getPathFileColumnCalleSaved(){
		return RUTA_ARCHIVO_EXCEL+FILE_COLUMN_CALLE_CLEARED;
	}
	
	public static String getPathFileColumnDesccfuhSaved(){
		return RUTA_ARCHIVO_EXCEL+FILE_COLUMN_DESC_CFUH_CLEARED;
	}
	
	public static String getPathFileColumnColFuhSaved(){
		return RUTA_ARCHIVO_EXCEL+FILE_COLUMN_COL_FUH_CLEARED;
	}
	
	public static String getPathFileColumnTenenTieSaved(){
		return RUTA_ARCHIVO_EXCEL+FILE_COLUMN_TENEN_TIE_CLEARED;
	}
	
	public static String getPathArchivoExcelToClear(){
		return RUTA_ARCHIVO_EXCEL+NOMBRE_ARCHIVO_EXCEL;
	}
	
	
	
	
}
